Tabela ContractOrgUnit

Definicja tabeli ContractOrgUnit

Name

ContractOrgUnit

Code

ContractOrgUnit

Comment

 


Lista kolumn tabeli ContractOrgUnit

Name

Code

ContractOrgUnitID

ContractOrgUnitID

Code

Code

ShortName

ShortName

FullName

FullName

Description

Description

Active

Active

InterfaceCd

InterfaceCd

CompanyStatisticalNo

CompanyStatisticalNo

StatCode

StatCode

StartDT

StartDT

StopDT

StopDT

IsSubContractor

IsSubContractor

InsurId

InsurId

HealthcareProviderCode

HealthcareProviderCode


Kolumna ContractOrgUnitID tabeli ContractOrgUnit

Definicja kolumny ContractOrgUnitID tabeli ContractOrgUnit

Name

ContractOrgUnitID

Code

ContractOrgUnitID

Data Type

NUMBER(10)

Mandatory

Yes

Comment

 


Kolumna Code tabeli ContractOrgUnit

Definicja kolumny Code tabeli ContractOrgUnit

Name

Code

Code

Code

Data Type

VARCHAR2(13)

Mandatory

No

Comment

PL: Kod wiersza
EN: Record's code
DE: Der code des Rekord


Kolumna ShortName tabeli ContractOrgUnit

Definicja kolumny ShortName tabeli ContractOrgUnit

Name

ShortName

Code

ShortName

Data Type

VARCHAR2(32)

Mandatory

No

Comment

PL: Skrócona nazwa wiersza
EN: Record's short name
DE: Der kurz Name des Rekord


Kolumna FullName tabeli ContractOrgUnit

Definicja kolumny FullName tabeli ContractOrgUnit

Name

FullName

Code

FullName

Data Type

VARCHAR2(255)

Mandatory

No

Comment

PL: Pelna nazwa wiersza
EN: Record's full name
DE: Der voll Name des Rekord


Kolumna Description tabeli ContractOrgUnit

Definicja kolumny Description tabeli ContractOrgUnit

Name

Description

Code

Description

Data Type

VARCHAR2(48)

Mandatory

No

Comment

PL: Opis wiersza
EN: Record's description
DE: Die Beschreibung des Rekord


Kolumna Active tabeli ContractOrgUnit

Definicja kolumny Active tabeli ContractOrgUnit

Name

Active

Code

Active

Data Type

NUMBER(5)

Mandatory

No

Comment

PL: Aktywnosc wiersza.
EN: Record's Activity
DE: Aktivitat des Rekord


Kolumna InterfaceCd tabeli ContractOrgUnit

Definicja kolumny InterfaceCd tabeli ContractOrgUnit

Name

InterfaceCd

Code

InterfaceCd

Data Type

VARCHAR2(32)

Mandatory

No

Comment

 


Kolumna CompanyStatisticalNo tabeli ContractOrgUnit

Definicja kolumny CompanyStatisticalNo tabeli ContractOrgUnit

Name

CompanyStatisticalNo

Code

CompanyStatisticalNo

Data Type

VARCHAR2(14)

Mandatory

No

Comment

 


Kolumna StatCode tabeli ContractOrgUnit

Definicja kolumny StatCode tabeli ContractOrgUnit

Name

StatCode

Code

StatCode

Data Type

VARCHAR2(32)

Mandatory

No

Comment

 


Kolumna StartDT tabeli ContractOrgUnit

Definicja kolumny StartDT tabeli ContractOrgUnit

Name

StartDT

Code

StartDT

Data Type

DATE

Mandatory

No

Comment

PL: Data poczatku
EN: Start date
DE: das Beginndatum


Kolumna StopDT tabeli ContractOrgUnit

Definicja kolumny StopDT tabeli ContractOrgUnit

Name

StopDT

Code

StopDT

Data Type

DATE

Mandatory

No

Comment

PL: Data koncowa
EN: Stop date
DE: Das Endedatum


Kolumna IsSubContractor tabeli ContractOrgUnit

Definicja kolumny IsSubContractor tabeli ContractOrgUnit

Name

IsSubContractor

Code

IsSubContractor

Data Type

NUMBER(5)

Mandatory

No

Comment

Definicje jednostek NFZ-owych bedacych podwykonawcami dla szpitala.


Kolumna InsurId tabeli ContractOrgUnit

Definicja kolumny InsurId tabeli ContractOrgUnit

Name

InsurId

Code

InsurId

Data Type

NUMBER(10)

Mandatory

No

Comment

ID oddzialu NFZ


Kolumna HealthcareProviderCode tabeli ContractOrgUnit

Definicja kolumny HealthcareProviderCode tabeli ContractOrgUnit

Name

HealthcareProviderCode

Code

HealthcareProviderCode

Data Type

VARCHAR2(24)

Mandatory

No

Comment

kod swiadczeniodawcy


Lista kluczy tabeli ContractOrgUnit

Name

Code

Primary

Identifier_1

Identifier_1

X


Klucz Identifier_1 tabeli ContractOrgUnit

Definicja klucza Identifier_1 tabeli ContractOrgUnit

Name

Identifier_1

Code

Identifier_1

Primary

Yes

Comment